Advance Diploma in Microsoft office ( MS office)

Word Processing: MS Word :
• Introduction to Word Processing
• Introduction to MS Word: features, Creating, Saving and Opening documents in Word, Interface, Toolbars, Ruler, Menus, Keyboard Shortcut.
• Editing a Document – Moving, Scrolling in a document, Opening Multi document windows, Editing Text – Selecting, Inserting, deleting, moving text.
• Previewing documents, Printing documents – Print a document from the standard toolbar, Print a document from the menu, shrinking a document to fit a page, Reduce the number of pages by one.
• Formatting Documents: Paragraph formats, Aligning Text and Paragraph, Borders and Shading, Headers and Footers, Multiple Columns.
Worksheet: MS Excel • Worksheet basics
• Creating worksheet, entering data into worksheet, heading information, data, text, dates, Cell formatting values, saving & protecting worksheet.
• Opening and moving around in an existing worksheet
• Toolbars and Menus, keyboard shortcuts
• Working with single and multiple workbook – coping, renaming, moving, adding and deleting, coping entries and moving between workbooks
• Working with formulas & cell referencing.
- Autosum
- Coping formulas
- Absolute & Relative addressing
• Working with ranges – creating, editing and selecting ranges, sorting.
• Formatting of worksheet – Auto format, changing – alignment, character styles, column width, date format, borders & , currency signs.
• Previewing & Printing worksheet – Page setting, Print titles, Adjusting margins, Page break, headers and footers.
• Graphs and charts – using wizards, various charts type, formatting grid lines & legends, previewing & printing charts.
Presentation Graphics: MS Power Point
• Features and various versions
• Creating presentation using Slide master and template in various colour scheme
• Working with different views and menus of power point
• Working with slides – Make new slide, move, copy, delete, duplicate, lay outing of slide, zoom in or out of a slide.
• Editing and formatting text: Alignment, editing, inserting, deleting, selecting, formatting of text, find and replace text.
• Bullets, footer, paragraph formatting, spell checking.
• Printing presentation – Print slides, notes, handouts and outlines.
• Inserting Objects – Drawing and inserting objects using Clip Art's pictures and charts.
• Custom Animation – slide transition effects and other animation effects.
• Presenting the show – making stand alone presentation.